﻿CREATE TABLE [dbo].[Item] (
    [Id]          INT           IDENTITY (1, 1) NOT NULL,
    [Updated]     DATETIME      NOT NULL,
    [Active]      BIT           NOT NULL,
    [Code]        NVARCHAR (20) NOT NULL,
    [Description] NVARCHAR (50) NULL,
    [UnitPrice]   MONEY         NOT NULL,
    CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Item_Code]
    ON [dbo].[Item]([Code] ASC);

